The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance
نویسندگان
چکیده
The design process is the most considered task of a data warehouse designer, this because of its performance criticality while going to production. Even if technology has developed in term of memory volume and speed, storage... the fact to minimize the execution time and the storage space still being a preoccupation for data warehousing specialists. This papers shows that using bitmap index and partitioned fact tables in data warehouse based on a star schema is more advantageous based on compression. References 1. Emany Sidi, Mohamed El Merouani and El Amin A Abdelouarit. Article: Star Schema
منابع مشابه
Dynamic Query Scheduling in Parallel Data Warehouses
Parallel processing is a key to high performance in very large data warehouse applications that execute complex analytical queries on huge amounts of data. Although parallel database systems (PDBSs) have been studied extensively in the past decades, the specifics of load balancing in parallel data warehouses have not been addressed in detail. In this study, we investigate how the load balancing...
متن کاملThe Dimension-Join: A New Index for Data Warehouses
There are several auxiliary pre-computed access structures that allow faster answers by reading less base data. Examples are materialized views, join indexes, B-tree and bitmap indexes. This paper proposes dimension-join, a new type of index especially suited for data warehouses. The dimension-join borrows ideas from several concepts. It is a bitmap index, it is a multi-table join and when bein...
متن کاملBitmap Indexing a Suitable Approach for Data Warehouse Design
Data warehouse is a collection of huge database which is subject oriented, integrated, time-variant and non volatile. As it is a set of huge database, fast data access is the major performance parameter of any data warehouse. Generally the information retrieved from Data Warehouse is summarized or aggregated as it is required for some decision making process of organization. To retrieve such a ...
متن کاملDimensions Based Data Clustering and Zone Maps
In recent years, the data warehouse industry has witnessed decreased use of indexing but increased use of compression and clustering of data facilitating efficient data access and data pruning in the query processing area. A classic example of data pruning is the partition pruning, which is used when table data is range or list partitioned. But lately, techniques have been developed to prune da...
متن کاملAn Efficient Method for Improving Query Efficiency in Data Warehouse
There are lots of performance bottlenecks for real-time queries in mass data. Many methods can only improve the efficiency for frequently used queries, but it is not advisable to neglect the non-frequently used queries. This paper proposes a new integrated index model called BBI and illustrates the application of this model. Based on the feature of data warehouse and OLAP queries, this index mo...
متن کامل